--This script should be executed in the database having the SSISServers table.

set nocount on;


--xact_abort being on makes the entire transaction (below) behave as a single unit.  All SQL within the
--transaction will succeed (if no errors occur) or fail (if an error occurs) as a unit.
set xact_abort on


--wrap DML SQL within a transaction
begin tran


--remove all old servers
delete
from
  BIMonitor.SSISServers
where
  Environment = 'Development'

--add new configuration settings
insert into BIMonitor.SSISServers(Environment,[Server]) values('Development','waBIETL1')


commit tran


--turn xact_abort off
set xact_abort off